-- created by kumiler
-- on 2023/4/20 10:22
-- DESC
CREATE external TABLE jms_ods.tab_bulk_cargo_area_record
   (CREATE_DATE string comment "创建时间",
        REGIONAL_DESC string comment "大区名称",
        REGIONAL_ID string comment "大区编码",
        PROVIDER_DESC string comment "省份名称",
        PROVIDER_ID string comment "省份编码",
        AGENT_NAME string comment "代理区名称",
        AGENT_CODE string comment "代理区编码",
        CENTER_NAME string comment "中心名称",
        CENTER_CODE string comment "中心编码",
        CITY_DESC string comment "城市名称",
        CITY_ID string comment "城市编码",
        AREA_DESC string comment "区县名称",
        AREA_ID string comment "区县编码",
        FIRST_TIME string comment "一散时间",
        SECOND_TIME string comment "二散时间",
        DELIVER_OVER_TIME string comment "派件加时",
        DELIVER_SPAN_DAY string comment "派件跨天"
   ) comment "散货班次记录数据"
    partitioned by (dt string comment "分区字段yyyy-MM-dd")
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
        WITH SERDEPROPERTIES (
        'serialization.format' = '1'
        )
    STORED AS
        INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
        OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
    LOCATION '/dw/hive/jms_ods.db/external/tab_bulk_cargo_area_record'
;
